--Setup the Table
DECLARE @T TABLE (wordname VARCHAR(25))
INSERT INTO @T VALUES ('"ASKHELLO"SE'),('""HELLO""1')
SELECT * FROM @T

--DECLARE AND SET XML REPLACING " with spaces
DECLARE @XML XML = 
(
SELECT ROW_NUMBER() OVER (ORDER BY wordname ASC) AS "@ID",
	  CONVERT(XML,'<PART>' + REPLACE(CAST(CAST(REPLACE(wordname, '"',' ') AS VARCHAR(25)) AS VARCHAR(max)),' ',' </PART><PART>') + '</PART>') AS Word
FROM	  @T AS T
	  FOR XML PATH('Node'), ROOT('Nodes'), ELEMENTS, TYPE
)
SELECT @XML


--SHRED THE XML (WHICH WILL REMOVE NULLS) AND TRIM
;WITH
SHRED AS
(
SELECT  ID = FieldAlias.value('(@ID)[1]','INT'),
	   WordName = FieldAlias.value('(Word)[1]','varchar(max)')
FROM	   @XML.nodes('/Nodes/Node') AS TableAlias(FieldAlias)
)
SELECT  S.ID,
	   LTRIM(RTRIM(S.WordName)) AS WordName
FROM	   Shred AS S
